package cn.web03.websocket.dao;

import cn.web03.websocket.po.SocketUser;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
/**
 * @author 零三 2020.06
 * https://web03.cn
 */
public interface SocketUserRepository extends JpaRepository<SocketUser,Long> {
    @Query(value = "select * from t_socket_user t where t.username = ?1 and t.password = ?2", nativeQuery = true)
    SocketUser checkedSocketUser(String username,String password);
}
